﻿CREATE TABLE [dbo].[PosturiVacante] (
    [IdPostVacant] INT          IDENTITY (1, 1) NOT NULL,
    [FUNCTIA]      VARCHAR (50) NOT NULL,
    [SPEC]         VARCHAR (50) NOT NULL,
    [NIVEL_STUDII] VARCHAR (1)  NULL,
    [Cuantum_post] DECIMAL (3)  NULL,
    [SAL FUNC]     DECIMAL (17) NULL,
    [COND]         VARCHAR (2)  NULL,
    [LEI_COND]     VARCHAR (10) NULL,
    [LEI_MERIT]    VARCHAR (10) NULL,
    [SPV]          VARCHAR (2)  NULL,
    [LEI_SPV]      VARCHAR (10) NULL,
    [NUME]         VARCHAR (30) NOT NULL,
    [COD_LM]       SMALLINT     NULL,
    [COD_FUNC]     INT          NOT NULL,
    [CodUnitate]   SMALLINT     CONSTRAINT [DF_PosturiVacante_CodUnitate] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_dsc_PosturiVacante] PRIMARY KEY CLUSTERED ([IdPostVacant] ASC)
);

